﻿<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
      <Schema Namespace="Хранилище ExRaspisDBModel" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
        <!--Ошибки, обнаруженные при создании:
предупреждение 6013: Первичный ключ в таблице или представлении "C:\USERS\АНТОН\YANDEXDISK\REPOS\SHEDULEPLANNER\EXRASPISDB.MDF.dbo.MONTH" не определен, его не удалось вывести. Эта таблица или представление исключены. Чтобы использовать сущность, необходимо проверить схему, добавить правильные ключи и раскомментировать ее.
        <EntityType Name="MONTH">
          <Property Name="MN" Type="tinyint" />
          <Property Name="NAIM" Type="nvarchar" MaxLength="15" />
        </EntityType>-->
        <EntityType Name="NED">
          <Key>
            <PropertyRef Name="id_ned" />
          </Key>
          <Property Name="id_ned" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="NAIM" Type="varchar" MaxLength="20" Nullable="false" />
        </EntityType>
        <EntityType Name="PLAN">
          <Key>
            <PropertyRef Name="IDN" />
          </Key>
          <Property Name="IDN" Type="int" Nullable="false" />
          <Property Name="IDP" Type="int" Nullable="false" />
          <Property Name="IDG" Type="int" Nullable="false" />
          <Property Name="IDD" Type="int" Nullable="false" />
          <Property Name="Ned_1" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_2" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_3" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_4" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_5" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_6" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_7" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_8" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_9" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_10" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_11" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_12" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_13" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_14" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_15" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_16" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_17" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_18" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_19" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_20" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_21" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_22" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_23" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_24" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_25" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_26" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_27" Type="nvarchar" MaxLength="20" />
          <Property Name="Ned_28" Type="nvarchar" MaxLength="20" />
        </EntityType>
        <!--Ошибки, обнаруженные при создании:
предупреждение 6002: В таблице или представлении "C:\USERS\АНТОН\YANDEXDISK\REPOS\SHEDULEPLANNER\EXRASPISDB.MDF.dbo.SPGRUP" не определен первичный ключ. Ключ был выведен, а определение таблицы или представления было создано в режиме только для чтения.-->
        <EntityType Name="SPGRUP">
          <Key>
            <PropertyRef Name="IDG" />
            <PropertyRef Name="FINAL" />
          </Key>
          <Property Name="IDG" Type="int" Nullable="false" />
          <Property Name="IDO" Type="int" />
          <Property Name="MEMO" Type="nvarchar" MaxLength="50" />
          <Property Name="IDA" Type="int" />
          <Property Name="IDP" Type="int" />
          <Property Name="IG" Type="smallint" />
          <Property Name="IDF" Type="int" />
          <Property Name="KURS" Type="smallint" />
          <Property Name="IDV" Type="int" />
          <Property Name="FINAL" Type="bit" Nullable="false" />
          <Property Name="DATNN" Type="datetime" />
          <Property Name="DATKK" Type="datetime" />
          <Property Name="kolStud" Type="int" />
          <Property Name="NAIM" Type="nvarchar" MaxLength="30" />
        </EntityType>
        <!--Ошибки, обнаруженные при создании:
предупреждение 6002: В таблице или представлении "C:\USERS\АНТОН\YANDEXDISK\REPOS\SHEDULEPLANNER\EXRASPISDB.MDF.dbo.SPNAGR" не определен первичный ключ. Ключ был выведен, а определение таблицы или представления было создано в режиме только для чтения.-->
        <EntityType Name="SPNAGR">
          <Key>
            <PropertyRef Name="IDN" />
            <PropertyRef Name="Po_Zam" />
            <PropertyRef Name="PRAKT" />
            <PropertyRef Name="WITHD" />
            <PropertyRef Name="NO_CALC" />
          </Key>
          <Property Name="IDN" Type="int" Nullable="false" />
          <Property Name="IDP" Type="int" />
          <Property Name="IDG" Type="int" />
          <Property Name="IDD" Type="int" />
          <Property Name="IDT" Type="int" />
          <Property Name="IDA" Type="int" />
          <Property Name="CHSEM" Type="smallint" />
          <Property Name="DATNN" Type="datetime" />
          <Property Name="DATKK" Type="datetime" />
          <Property Name="CH" Type="smallint" />
          <Property Name="IDGG" Type="tinyint" />
          <Property Name="NAZNA" Type="smallint" />
          <Property Name="Po_Zam" Type="bit" Nullable="false" />
          <Property Name="K_UR" Type="smallint" />
          <Property Name="IN" Type="int" />
          <Property Name="MEMO" Type="nvarchar" MaxLength="50" />
          <Property Name="CZP" Type="smallint" />
          <Property Name="CDO" Type="smallint" />
          <Property Name="CUR" Type="smallint" />
          <Property Name="UR_DAY" Type="real" />
          <Property Name="CPL" Type="smallint" />
          <Property Name="PRAKT" Type="bit" Nullable="false" />
          <Property Name="WITHD" Type="bit" Nullable="false" />
          <Property Name="CZPD" Type="smallint" />
          <Property Name="PRAKD" Type="smallint" />
          <Property Name="CURP" Type="smallint" />
          <Property Name="UR_DAYP" Type="real" />
          <Property Name="IDZ" Type="int" />
          <Property Name="IDNN" Type="int" />
          <Property Name="NO_CALC" Type="bit" Nullable="false" />
        </EntityType>
        <!--Ошибки, обнаруженные при создании:
предупреждение 6002: В таблице или представлении "C:\USERS\АНТОН\YANDEXDISK\REPOS\SHEDULEPLANNER\EXRASPISDB.MDF.dbo.SPPRED" не определен первичный ключ. Ключ был выведен, а определение таблицы или представления было создано в режиме только для чтения.-->
        <EntityType Name="SPPRED">
          <Key>
            <PropertyRef Name="IDD" />
          </Key>
          <Property Name="IDD" Type="int" Nullable="false" />
          <Property Name="KOD" Type="nvarchar" MaxLength="20" />
          <Property Name="MEMO" Type="nvarchar" MaxLength="255" />
          <Property Name="TRUD" Type="int" />
          <Property Name="NAIM" Type="nvarchar" MaxLength="255" />
        </EntityType>
        <!--Ошибки, обнаруженные при создании:
предупреждение 6002: В таблице или представлении "C:\USERS\АНТОН\YANDEXDISK\REPOS\SHEDULEPLANNER\EXRASPISDB.MDF.dbo.SPPREP" не определен первичный ключ. Ключ был выведен, а определение таблицы или представления было создано в режиме только для чтения.-->
        <EntityType Name="SPPREP">
          <Key>
            <PropertyRef Name="IDP" />
          </Key>
          <Property Name="IDP" Type="int" Nullable="false" />
          <Property Name="IDK" Type="int" />
          <Property Name="IDA" Type="int" />
          <Property Name="IP" Type="smallint" />
          <Property Name="MEMO" Type="nvarchar" MaxLength="50" />
          <Property Name="TABNOM" Type="nvarchar" MaxLength="10" />
          <Property Name="ADRESS" Type="nvarchar(max)" />
          <Property Name="PHONE" Type="nvarchar" MaxLength="255" />
          <Property Name="FAMIO" Type="nvarchar" MaxLength="255" />
        </EntityType>
        <EntityType Name="sysdiagrams">
          <Key>
            <PropertyRef Name="diagram_id" />
          </Key>
          <Property Name="name" Type="nvarchar" MaxLength="128" Nullable="false" />
          <Property Name="principal_id" Type="int" Nullable="false" />
          <Property Name="diagram_id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="version" Type="int" />
          <Property Name="definition" Type="varbinary(max)" />
        </EntityType>
        <!--Ошибки, обнаруженные при создании:
предупреждение 6002: В таблице или представлении "C:\USERS\АНТОН\YANDEXDISK\REPOS\SHEDULEPLANNER\EXRASPISDB.MDF.dbo.UROKI" не определен первичный ключ. Ключ был выведен, а определение таблицы или представления было создано в режиме только для чтения.-->
        <EntityType Name="UROKI">
          <Key>
            <PropertyRef Name="ID" />
            <PropertyRef Name="ZP" />
            <PropertyRef Name="MORE" />
            <PropertyRef Name="HAND" />
          </Key>
          <Property Name="ID" Type="int" Nullable="false" />
          <Property Name="DAT" Type="date" />
          <Property Name="UR" Type="int" />
          <Property Name="IDP" Type="int" />
          <Property Name="IDG" Type="int" />
          <Property Name="IDGG" Type="int" />
          <Property Name="IDA" Type="int" />
          <Property Name="IDD" Type="int" />
          <Property Name="IDN" Type="int" />
          <Property Name="IDR" Type="int" />
          <Property Name="ZP" Type="bit" Nullable="false" />
          <Property Name="MORE" Type="bit" Nullable="false" />
          <Property Name="IDI" Type="int" />
          <Property Name="IDNN" Type="int" />
          <Property Name="IDU" Type="int" />
          <Property Name="DT" Type="datetime" />
          <Property Name="HAND" Type="bit" Nullable="false" />
        </EntityType>
        <Function Name="CountUroki" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="IDP" Type="int" Mode="In" />
          <Parameter Name="IDG" Type="int" Mode="In" />
          <Parameter Name="IDD" Type="int" Mode="In" />
          <Parameter Name="DAT" Type="date" Mode="In" />
        </Function>
        <Function Name="CountUroki_Otchet_interval" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="IDP" Type="int" Mode="In" />
          <Parameter Name="IDG" Type="int" Mode="In" />
          <Parameter Name="IDD" Type="int" Mode="In" />
          <Parameter Name="DAT_N" Type="date" Mode="In" />
          <Parameter Name="DAT_K" Type="date" Mode="In" />
        </Function>
        <Function Name="fn_diagramobjects" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="true" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" ReturnType="int" />
        <Function Name="MergePlan" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" />
        <Function Name="pr_LoadGroup" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" />
        <Function Name="pr_LoadNagrGroup" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="IDG" Type="int" Mode="In" />
        </Function>
        <Function Name="pr_LoadNagrPrepod" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="IDP" Type="int" Mode="In" />
        </Function>
        <Function Name="pr_LoadPlan" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="IDP" Type="int" Mode="In" />
          <Parameter Name="IDG" Type="int" Mode="In" />
          <Parameter Name="IDD" Type="int" Mode="In" />
        </Function>
        <Function Name="pr_LoadPrepod" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" />
        <Function Name="sp_alterdiagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
          <Parameter Name="owner_id" Type="int" Mode="In" />
          <Parameter Name="version" Type="int" Mode="In" />
          <Parameter Name="definition" Type="varbinary(max)" Mode="In" />
        </Function>
        <Function Name="sp_creatediagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
          <Parameter Name="owner_id" Type="int" Mode="In" />
          <Parameter Name="version" Type="int" Mode="In" />
          <Parameter Name="definition" Type="varbinary(max)" Mode="In" />
        </Function>
        <Function Name="sp_dropdiagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
          <Parameter Name="owner_id" Type="int" Mode="In" />
        </Function>
        <Function Name="sp_helpdiagramdefinition" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
          <Parameter Name="owner_id" Type="int" Mode="In" />
        </Function>
        <Function Name="sp_helpdiagrams" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
          <Parameter Name="owner_id" Type="int" Mode="In" />
        </Function>
        <Function Name="sp_renamediagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
          <Parameter Name="owner_id" Type="int" Mode="In" />
          <Parameter Name="new_diagramname" Type="nvarchar" Mode="In" />
        </Function>
        <Function Name="sp_upgraddiagrams" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" />
        <EntityContainer Name="Хранилище ExRaspisDBModelContainer">
          <EntitySet Name="NED" EntityType="Self.NED" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="PLAN" EntityType="Self.PLAN" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="SPGRUP" EntityType="Self.SPGRUP" store:Type="Tables" store:Schema="dbo">
            <DefiningQuery>SELECT 
    [SPGRUP].[IDG] AS [IDG], 
    [SPGRUP].[IDO] AS [IDO], 
    [SPGRUP].[MEMO] AS [MEMO], 
    [SPGRUP].[IDA] AS [IDA], 
    [SPGRUP].[IDP] AS [IDP], 
    [SPGRUP].[IG] AS [IG], 
    [SPGRUP].[IDF] AS [IDF], 
    [SPGRUP].[KURS] AS [KURS], 
    [SPGRUP].[IDV] AS [IDV], 
    [SPGRUP].[FINAL] AS [FINAL], 
    [SPGRUP].[DATNN] AS [DATNN], 
    [SPGRUP].[DATKK] AS [DATKK], 
    [SPGRUP].[kolStud] AS [kolStud], 
    [SPGRUP].[NAIM] AS [NAIM]
    FROM [dbo].[SPGRUP] AS [SPGRUP]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="SPNAGR" EntityType="Self.SPNAGR" store:Type="Tables" store:Schema="dbo">
            <DefiningQuery>SELECT 
    [SPNAGR].[IDN] AS [IDN], 
    [SPNAGR].[IDP] AS [IDP], 
    [SPNAGR].[IDG] AS [IDG], 
    [SPNAGR].[IDD] AS [IDD], 
    [SPNAGR].[IDT] AS [IDT], 
    [SPNAGR].[IDA] AS [IDA], 
    [SPNAGR].[CHSEM] AS [CHSEM], 
    [SPNAGR].[DATNN] AS [DATNN], 
    [SPNAGR].[DATKK] AS [DATKK], 
    [SPNAGR].[CH] AS [CH], 
    [SPNAGR].[IDGG] AS [IDGG], 
    [SPNAGR].[NAZNA] AS [NAZNA], 
    [SPNAGR].[Po_Zam] AS [Po_Zam], 
    [SPNAGR].[K_UR] AS [K_UR], 
    [SPNAGR].[IN] AS [IN], 
    [SPNAGR].[MEMO] AS [MEMO], 
    [SPNAGR].[CZP] AS [CZP], 
    [SPNAGR].[CDO] AS [CDO], 
    [SPNAGR].[CUR] AS [CUR], 
    [SPNAGR].[UR_DAY] AS [UR_DAY], 
    [SPNAGR].[CPL] AS [CPL], 
    [SPNAGR].[PRAKT] AS [PRAKT], 
    [SPNAGR].[WITHD] AS [WITHD], 
    [SPNAGR].[CZPD] AS [CZPD], 
    [SPNAGR].[PRAKD] AS [PRAKD], 
    [SPNAGR].[CURP] AS [CURP], 
    [SPNAGR].[UR_DAYP] AS [UR_DAYP], 
    [SPNAGR].[IDZ] AS [IDZ], 
    [SPNAGR].[IDNN] AS [IDNN], 
    [SPNAGR].[NO_CALC] AS [NO_CALC]
    FROM [dbo].[SPNAGR] AS [SPNAGR]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="SPPRED" EntityType="Self.SPPRED" store:Type="Tables" store:Schema="dbo">
            <DefiningQuery>SELECT 
    [SPPRED].[IDD] AS [IDD], 
    [SPPRED].[KOD] AS [KOD], 
    [SPPRED].[MEMO] AS [MEMO], 
    [SPPRED].[TRUD] AS [TRUD], 
    [SPPRED].[NAIM] AS [NAIM]
    FROM [dbo].[SPPRED] AS [SPPRED]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="SPPREP" EntityType="Self.SPPREP" store:Type="Tables" store:Schema="dbo">
            <DefiningQuery>SELECT 
    [SPPREP].[IDP] AS [IDP], 
    [SPPREP].[IDK] AS [IDK], 
    [SPPREP].[IDA] AS [IDA], 
    [SPPREP].[IP] AS [IP], 
    [SPPREP].[MEMO] AS [MEMO], 
    [SPPREP].[TABNOM] AS [TABNOM], 
    [SPPREP].[ADRESS] AS [ADRESS], 
    [SPPREP].[PHONE] AS [PHONE], 
    [SPPREP].[FAMIO] AS [FAMIO]
    FROM [dbo].[SPPREP] AS [SPPREP]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="UROKI" EntityType="Self.UROKI" store:Type="Tables" store:Schema="dbo">
            <DefiningQuery>SELECT 
    [UROKI].[ID] AS [ID], 
    [UROKI].[DAT] AS [DAT], 
    [UROKI].[UR] AS [UR], 
    [UROKI].[IDP] AS [IDP], 
    [UROKI].[IDG] AS [IDG], 
    [UROKI].[IDGG] AS [IDGG], 
    [UROKI].[IDA] AS [IDA], 
    [UROKI].[IDD] AS [IDD], 
    [UROKI].[IDN] AS [IDN], 
    [UROKI].[IDR] AS [IDR], 
    [UROKI].[ZP] AS [ZP], 
    [UROKI].[MORE] AS [MORE], 
    [UROKI].[IDI] AS [IDI], 
    [UROKI].[IDNN] AS [IDNN], 
    [UROKI].[IDU] AS [IDU], 
    [UROKI].[DT] AS [DT], 
    [UROKI].[HAND] AS [HAND]
    FROM [dbo].[UROKI] AS [UROKI]</DefiningQuery>
          </EntitySet>
        </EntityContainer>
      </Schema>
    </edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="ExRaspisDBModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
        <EntityType Name="NED">
          <Key>
            <PropertyRef Name="id_ned" />
          </Key>
          <Property Name="id_ned" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="NAIM" Type="String" MaxLength="20" FixedLength="false" Unicode="false" Nullable="false" />
        </EntityType>
        <EntityType Name="PLAN">
          <Key>
            <PropertyRef Name="IDN" />
          </Key>
          <Property Name="IDN" Type="Int32" Nullable="false" />
          <Property Name="IDP" Type="Int32" Nullable="false" />
          <Property Name="IDG" Type="Int32" Nullable="false" />
          <Property Name="IDD" Type="Int32" Nullable="false" />
          <Property Name="Ned_1" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_2" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_3" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_4" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_5" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_6" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_7" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_8" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_9" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_10" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_11" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_12" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_13" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_14" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_15" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_16" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_17" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_18" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_19" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_20" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_21" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_22" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_23" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_24" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_25" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_26" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_27" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="Ned_28" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="sysdiagrams">
          <Key>
            <PropertyRef Name="diagram_id" />
          </Key>
          <Property Name="name" Type="String" MaxLength="128" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="principal_id" Type="Int32" Nullable="false" />
          <Property Name="diagram_id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="version" Type="Int32" />
          <Property Name="definition" Type="Binary" MaxLength="Max" FixedLength="false" />
        </EntityType>
        <EntityType Name="SPGRUP">
          <Key>
            <PropertyRef Name="IDG" />
            <PropertyRef Name="FINAL" />
          </Key>
          <Property Name="IDG" Type="Int32" Nullable="false" />
          <Property Name="IDO" Type="Int32" />
          <Property Name="MEMO" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="IDA" Type="Int32" />
          <Property Name="IDP" Type="Int32" />
          <Property Name="IG" Type="Int16" />
          <Property Name="IDF" Type="Int32" />
          <Property Name="KURS" Type="Int16" />
          <Property Name="IDV" Type="Int32" />
          <Property Name="FINAL" Type="Boolean" Nullable="false" />
          <Property Name="DATNN" Type="DateTime" Precision="3" />
          <Property Name="DATKK" Type="DateTime" Precision="3" />
          <Property Name="kolStud" Type="Int32" />
          <Property Name="NAIM" Type="String" MaxLength="30" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="SPNAGR">
          <Key>
            <PropertyRef Name="IDN" />
            <PropertyRef Name="Po_Zam" />
            <PropertyRef Name="PRAKT" />
            <PropertyRef Name="WITHD" />
            <PropertyRef Name="NO_CALC" />
          </Key>
          <Property Name="IDN" Type="Int32" Nullable="false" />
          <Property Name="IDP" Type="Int32" />
          <Property Name="IDG" Type="Int32" />
          <Property Name="IDD" Type="Int32" />
          <Property Name="IDT" Type="Int32" />
          <Property Name="IDA" Type="Int32" />
          <Property Name="CHSEM" Type="Int16" />
          <Property Name="DATNN" Type="DateTime" Precision="3" />
          <Property Name="DATKK" Type="DateTime" Precision="3" />
          <Property Name="CH" Type="Int16" />
          <Property Name="IDGG" Type="Byte" />
          <Property Name="NAZNA" Type="Int16" />
          <Property Name="Po_Zam" Type="Boolean" Nullable="false" />
          <Property Name="K_UR" Type="Int16" />
          <Property Name="IN" Type="Int32" />
          <Property Name="MEMO" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="CZP" Type="Int16" />
          <Property Name="CDO" Type="Int16" />
          <Property Name="CUR" Type="Int16" />
          <Property Name="UR_DAY" Type="Single" />
          <Property Name="CPL" Type="Int16" />
          <Property Name="PRAKT" Type="Boolean" Nullable="false" />
          <Property Name="WITHD" Type="Boolean" Nullable="false" />
          <Property Name="CZPD" Type="Int16" />
          <Property Name="PRAKD" Type="Int16" />
          <Property Name="CURP" Type="Int16" />
          <Property Name="UR_DAYP" Type="Single" />
          <Property Name="IDZ" Type="Int32" />
          <Property Name="IDNN" Type="Int32" />
          <Property Name="NO_CALC" Type="Boolean" Nullable="false" />
        </EntityType>
        <EntityType Name="SPPRED">
          <Key>
            <PropertyRef Name="IDD" />
          </Key>
          <Property Name="IDD" Type="Int32" Nullable="false" />
          <Property Name="KOD" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="MEMO" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="TRUD" Type="Int32" />
          <Property Name="NAIM" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="SPPREP">
          <Key>
            <PropertyRef Name="IDP" />
          </Key>
          <Property Name="IDP" Type="Int32" Nullable="false" />
          <Property Name="IDK" Type="Int32" />
          <Property Name="IDA" Type="Int32" />
          <Property Name="IP" Type="Int16" />
          <Property Name="MEMO" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="TABNOM" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
          <Property Name="ADRESS" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
          <Property Name="PHONE" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
          <Property Name="FAMIO" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="UROKI">
          <Key>
            <PropertyRef Name="ID" />
            <PropertyRef Name="ZP" />
            <PropertyRef Name="MORE" />
            <PropertyRef Name="HAND" />
          </Key>
          <Property Name="ID" Type="Int32" Nullable="false" />
          <Property Name="DAT" Type="DateTime" Precision="0" />
          <Property Name="UR" Type="Int32" />
          <Property Name="IDP" Type="Int32" />
          <Property Name="IDG" Type="Int32" />
          <Property Name="IDGG" Type="Int32" />
          <Property Name="IDA" Type="Int32" />
          <Property Name="IDD" Type="Int32" />
          <Property Name="IDN" Type="Int32" />
          <Property Name="IDR" Type="Int32" />
          <Property Name="ZP" Type="Boolean" Nullable="false" />
          <Property Name="MORE" Type="Boolean" Nullable="false" />
          <Property Name="IDI" Type="Int32" />
          <Property Name="IDNN" Type="Int32" />
          <Property Name="IDU" Type="Int32" />
          <Property Name="DT" Type="DateTime" Precision="3" />
          <Property Name="HAND" Type="Boolean" Nullable="false" />
        </EntityType>
        <EntityContainer Name="ExRaspisDBEntities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="NED" EntityType="Self.NED" />
          <EntitySet Name="PLAN" EntityType="Self.PLAN" />
          <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" />
          <EntitySet Name="SPGRUP" EntityType="Self.SPGRUP" />
          <EntitySet Name="SPNAGR" EntityType="Self.SPNAGR" />
          <EntitySet Name="SPPRED" EntityType="Self.SPPRED" />
          <EntitySet Name="SPPREP" EntityType="Self.SPPREP" />
          <EntitySet Name="UROKI" EntityType="Self.UROKI" />
          <FunctionImport Name="CountUroki" ReturnType="Collection(Int32)">
            <Parameter Name="IDP" Mode="In" Type="Int32" />
            <Parameter Name="IDG" Mode="In" Type="Int32" />
            <Parameter Name="IDD" Mode="In" Type="Int32" />
            <Parameter Name="DAT" Mode="In" Type="DateTime" />
          </FunctionImport>
          <FunctionImport Name="CountUroki_Otchet_interval" ReturnType="Collection(Int32)">
            <Parameter Name="IDP" Mode="In" Type="Int32" />
            <Parameter Name="IDG" Mode="In" Type="Int32" />
            <Parameter Name="IDD" Mode="In" Type="Int32" />
            <Parameter Name="DAT_N" Mode="In" Type="DateTime" />
            <Parameter Name="DAT_K" Mode="In" Type="DateTime" />
          </FunctionImport>
          <FunctionImport Name="MergePlan" />
          <FunctionImport Name="pr_LoadGroup" ReturnType="Collection(ExRaspisDBModel.pr_LoadGroup_Result)" />
          <FunctionImport Name="pr_LoadNagrGroup" ReturnType="Collection(ExRaspisDBModel.pr_LoadNagrGroup_Result)">
            <Parameter Name="IDG" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="pr_LoadNagrPrepod" ReturnType="Collection(ExRaspisDBModel.pr_LoadNagrPrepod_Result)">
            <Parameter Name="IDP" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="pr_LoadPlan" ReturnType="Collection(ExRaspisDBModel.pr_LoadPlan_Result)">
            <Parameter Name="IDP" Mode="In" Type="Int32" />
            <Parameter Name="IDG" Mode="In" Type="Int32" />
            <Parameter Name="IDD" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="pr_LoadPrepod" ReturnType="Collection(ExRaspisDBModel.pr_LoadPrepod_Result)" />
          <FunctionImport Name="sp_alterdiagram">
            <Parameter Name="diagramname" Mode="In" Type="String" />
            <Parameter Name="owner_id" Mode="In" Type="Int32" />
            <Parameter Name="version" Mode="In" Type="Int32" />
            <Parameter Name="definition" Mode="In" Type="Binary" />
          </FunctionImport>
          <FunctionImport Name="sp_creatediagram">
            <Parameter Name="diagramname" Mode="In" Type="String" />
            <Parameter Name="owner_id" Mode="In" Type="Int32" />
            <Parameter Name="version" Mode="In" Type="Int32" />
            <Parameter Name="definition" Mode="In" Type="Binary" />
          </FunctionImport>
          <FunctionImport Name="sp_dropdiagram">
            <Parameter Name="diagramname" Mode="In" Type="String" />
            <Parameter Name="owner_id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="sp_helpdiagramdefinition" ReturnType="Collection(ExRaspisDBModel.sp_helpdiagramdefinition_Result)">
            <Parameter Name="diagramname" Mode="In" Type="String" />
            <Parameter Name="owner_id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="sp_helpdiagrams" ReturnType="Collection(ExRaspisDBModel.sp_helpdiagrams_Result)">
            <Parameter Name="diagramname" Mode="In" Type="String" />
            <Parameter Name="owner_id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="sp_renamediagram">
            <Parameter Name="diagramname" Mode="In" Type="String" />
            <Parameter Name="owner_id" Mode="In" Type="Int32" />
            <Parameter Name="new_diagramname" Mode="In" Type="String" />
          </FunctionImport>
          <FunctionImport Name="sp_upgraddiagrams" />
        </EntityContainer>
        <ComplexType Name="pr_LoadGroup_Result">
          <Property Type="Int32" Name="IDG" Nullable="false" />
          <Property Type="String" Name="NAIM" Nullable="true" MaxLength="30" />
        </ComplexType>
        <ComplexType Name="pr_LoadNagrGroup_Result">
          <Property Type="Int32" Name="IDG" Nullable="true" />
          <Property Type="Int32" Name="IDP" Nullable="true" />
          <Property Type="Int32" Name="IDD" Nullable="true" />
          <Property Type="String" Name="Преподаватель" Nullable="true" MaxLength="255" />
          <Property Type="String" Name="Дисциплина" Nullable="true" MaxLength="255" />
          <Property Type="Byte" Name="п_г" Nullable="true" />
          <Property Type="Int16" Name="Всего" Nullable="true" />
        </ComplexType>
        <ComplexType Name="pr_LoadNagrPrepod_Result">
          <Property Type="Int32" Name="IDP" Nullable="true" />
          <Property Type="Int32" Name="IDG" Nullable="true" />
          <Property Type="Int32" Name="IDD" Nullable="true" />
          <Property Type="String" Name="Группа" Nullable="true" MaxLength="30" />
          <Property Type="String" Name="Дисциплина" Nullable="true" MaxLength="255" />
          <Property Type="Byte" Name="п_г" Nullable="true" />
          <Property Type="Int16" Name="Всего" Nullable="true" />
        </ComplexType>
        <ComplexType Name="pr_LoadPlan_Result">
          <Property Type="String" Name="Ned_1" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_2" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_3" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_4" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_5" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_6" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_7" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_8" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_9" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_10" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_11" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_12" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_13" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_14" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_15" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_16" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_17" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_18" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_19" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_20" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_21" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_22" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_23" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_24" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_25" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_26" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_27" Nullable="true" MaxLength="20" />
          <Property Type="String" Name="Ned_28" Nullable="true" MaxLength="20" />
        </ComplexType>
        <ComplexType Name="pr_LoadPrepod_Result">
          <Property Type="Int32" Name="IDP" Nullable="false" />
          <Property Type="String" Name="FAMIO" Nullable="true" MaxLength="255" />
        </ComplexType>
        <ComplexType Name="sp_helpdiagramdefinition_Result">
          <Property Type="Int32" Name="version" Nullable="true" />
          <Property Type="Binary" Name="definition" Nullable="true" />
        </ComplexType>
        <ComplexType Name="sp_helpdiagrams_Result">
          <Property Type="String" Name="Database" Nullable="true" MaxLength="128" />
          <Property Type="String" Name="Name" Nullable="false" MaxLength="128" />
          <Property Type="Int32" Name="ID" Nullable="false" />
          <Property Type="String" Name="Owner" Nullable="true" MaxLength="128" />
          <Property Type="Int32" Name="OwnerID" Nullable="false" />
        </ComplexType>
      </Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
      <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
        <EntityContainerMapping StorageEntityContainer="Хранилище ExRaspisDBModelContainer" CdmEntityContainer="ExRaspisDBEntities">
          <EntitySetMapping Name="NED">
            <EntityTypeMapping TypeName="ExRaspisDBModel.NED">
              <MappingFragment StoreEntitySet="NED">
                <ScalarProperty Name="id_ned" ColumnName="id_ned" />
                <ScalarProperty Name="NAIM" ColumnName="NAIM" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="PLAN">
            <EntityTypeMapping TypeName="ExRaspisDBModel.PLAN">
              <MappingFragment StoreEntitySet="PLAN">
                <ScalarProperty Name="IDN" ColumnName="IDN" />
                <ScalarProperty Name="IDP" ColumnName="IDP" />
                <ScalarProperty Name="IDG" ColumnName="IDG" />
                <ScalarProperty Name="IDD" ColumnName="IDD" />
                <ScalarProperty Name="Ned_1" ColumnName="Ned_1" />
                <ScalarProperty Name="Ned_2" ColumnName="Ned_2" />
                <ScalarProperty Name="Ned_3" ColumnName="Ned_3" />
                <ScalarProperty Name="Ned_4" ColumnName="Ned_4" />
                <ScalarProperty Name="Ned_5" ColumnName="Ned_5" />
                <ScalarProperty Name="Ned_6" ColumnName="Ned_6" />
                <ScalarProperty Name="Ned_7" ColumnName="Ned_7" />
                <ScalarProperty Name="Ned_8" ColumnName="Ned_8" />
                <ScalarProperty Name="Ned_9" ColumnName="Ned_9" />
                <ScalarProperty Name="Ned_10" ColumnName="Ned_10" />
                <ScalarProperty Name="Ned_11" ColumnName="Ned_11" />
                <ScalarProperty Name="Ned_12" ColumnName="Ned_12" />
                <ScalarProperty Name="Ned_13" ColumnName="Ned_13" />
                <ScalarProperty Name="Ned_14" ColumnName="Ned_14" />
                <ScalarProperty Name="Ned_15" ColumnName="Ned_15" />
                <ScalarProperty Name="Ned_16" ColumnName="Ned_16" />
                <ScalarProperty Name="Ned_17" ColumnName="Ned_17" />
                <ScalarProperty Name="Ned_18" ColumnName="Ned_18" />
                <ScalarProperty Name="Ned_19" ColumnName="Ned_19" />
                <ScalarProperty Name="Ned_20" ColumnName="Ned_20" />
                <ScalarProperty Name="Ned_21" ColumnName="Ned_21" />
                <ScalarProperty Name="Ned_22" ColumnName="Ned_22" />
                <ScalarProperty Name="Ned_23" ColumnName="Ned_23" />
                <ScalarProperty Name="Ned_24" ColumnName="Ned_24" />
                <ScalarProperty Name="Ned_25" ColumnName="Ned_25" />
                <ScalarProperty Name="Ned_26" ColumnName="Ned_26" />
                <ScalarProperty Name="Ned_27" ColumnName="Ned_27" />
                <ScalarProperty Name="Ned_28" ColumnName="Ned_28" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="sysdiagrams">
            <EntityTypeMapping TypeName="ExRaspisDBModel.sysdiagrams">
              <MappingFragment StoreEntitySet="sysdiagrams">
                <ScalarProperty Name="name" ColumnName="name" />
                <ScalarProperty Name="principal_id" ColumnName="principal_id" />
                <ScalarProperty Name="diagram_id" ColumnName="diagram_id" />
                <ScalarProperty Name="version" ColumnName="version" />
                <ScalarProperty Name="definition" ColumnName="definition" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="SPGRUP">
            <EntityTypeMapping TypeName="ExRaspisDBModel.SPGRUP">
              <MappingFragment StoreEntitySet="SPGRUP">
                <ScalarProperty Name="IDG" ColumnName="IDG" />
                <ScalarProperty Name="IDO" ColumnName="IDO" />
                <ScalarProperty Name="MEMO" ColumnName="MEMO" />
                <ScalarProperty Name="IDA" ColumnName="IDA" />
                <ScalarProperty Name="IDP" ColumnName="IDP" />
                <ScalarProperty Name="IG" ColumnName="IG" />
                <ScalarProperty Name="IDF" ColumnName="IDF" />
                <ScalarProperty Name="KURS" ColumnName="KURS" />
                <ScalarProperty Name="IDV" ColumnName="IDV" />
                <ScalarProperty Name="FINAL" ColumnName="FINAL" />
                <ScalarProperty Name="DATNN" ColumnName="DATNN" />
                <ScalarProperty Name="DATKK" ColumnName="DATKK" />
                <ScalarProperty Name="kolStud" ColumnName="kolStud" />
                <ScalarProperty Name="NAIM" ColumnName="NAIM" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="SPNAGR">
            <EntityTypeMapping TypeName="ExRaspisDBModel.SPNAGR">
              <MappingFragment StoreEntitySet="SPNAGR">
                <ScalarProperty Name="IDN" ColumnName="IDN" />
                <ScalarProperty Name="IDP" ColumnName="IDP" />
                <ScalarProperty Name="IDG" ColumnName="IDG" />
                <ScalarProperty Name="IDD" ColumnName="IDD" />
                <ScalarProperty Name="IDT" ColumnName="IDT" />
                <ScalarProperty Name="IDA" ColumnName="IDA" />
                <ScalarProperty Name="CHSEM" ColumnName="CHSEM" />
                <ScalarProperty Name="DATNN" ColumnName="DATNN" />
                <ScalarProperty Name="DATKK" ColumnName="DATKK" />
                <ScalarProperty Name="CH" ColumnName="CH" />
                <ScalarProperty Name="IDGG" ColumnName="IDGG" />
                <ScalarProperty Name="NAZNA" ColumnName="NAZNA" />
                <ScalarProperty Name="Po_Zam" ColumnName="Po_Zam" />
                <ScalarProperty Name="K_UR" ColumnName="K_UR" />
                <ScalarProperty Name="IN" ColumnName="IN" />
                <ScalarProperty Name="MEMO" ColumnName="MEMO" />
                <ScalarProperty Name="CZP" ColumnName="CZP" />
                <ScalarProperty Name="CDO" ColumnName="CDO" />
                <ScalarProperty Name="CUR" ColumnName="CUR" />
                <ScalarProperty Name="UR_DAY" ColumnName="UR_DAY" />
                <ScalarProperty Name="CPL" ColumnName="CPL" />
                <ScalarProperty Name="PRAKT" ColumnName="PRAKT" />
                <ScalarProperty Name="WITHD" ColumnName="WITHD" />
                <ScalarProperty Name="CZPD" ColumnName="CZPD" />
                <ScalarProperty Name="PRAKD" ColumnName="PRAKD" />
                <ScalarProperty Name="CURP" ColumnName="CURP" />
                <ScalarProperty Name="UR_DAYP" ColumnName="UR_DAYP" />
                <ScalarProperty Name="IDZ" ColumnName="IDZ" />
                <ScalarProperty Name="IDNN" ColumnName="IDNN" />
                <ScalarProperty Name="NO_CALC" ColumnName="NO_CALC" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="SPPRED">
            <EntityTypeMapping TypeName="ExRaspisDBModel.SPPRED">
              <MappingFragment StoreEntitySet="SPPRED">
                <ScalarProperty Name="IDD" ColumnName="IDD" />
                <ScalarProperty Name="KOD" ColumnName="KOD" />
                <ScalarProperty Name="MEMO" ColumnName="MEMO" />
                <ScalarProperty Name="TRUD" ColumnName="TRUD" />
                <ScalarProperty Name="NAIM" ColumnName="NAIM" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="SPPREP">
            <EntityTypeMapping TypeName="ExRaspisDBModel.SPPREP">
              <MappingFragment StoreEntitySet="SPPREP">
                <ScalarProperty Name="IDP" ColumnName="IDP" />
                <ScalarProperty Name="IDK" ColumnName="IDK" />
                <ScalarProperty Name="IDA" ColumnName="IDA" />
                <ScalarProperty Name="IP" ColumnName="IP" />
                <ScalarProperty Name="MEMO" ColumnName="MEMO" />
                <ScalarProperty Name="TABNOM" ColumnName="TABNOM" />
                <ScalarProperty Name="ADRESS" ColumnName="ADRESS" />
                <ScalarProperty Name="PHONE" ColumnName="PHONE" />
                <ScalarProperty Name="FAMIO" ColumnName="FAMIO" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="UROKI">
            <EntityTypeMapping TypeName="ExRaspisDBModel.UROKI">
              <MappingFragment StoreEntitySet="UROKI">
                <ScalarProperty Name="ID" ColumnName="ID" />
                <ScalarProperty Name="DAT" ColumnName="DAT" />
                <ScalarProperty Name="UR" ColumnName="UR" />
                <ScalarProperty Name="IDP" ColumnName="IDP" />
                <ScalarProperty Name="IDG" ColumnName="IDG" />
                <ScalarProperty Name="IDGG" ColumnName="IDGG" />
                <ScalarProperty Name="IDA" ColumnName="IDA" />
                <ScalarProperty Name="IDD" ColumnName="IDD" />
                <ScalarProperty Name="IDN" ColumnName="IDN" />
                <ScalarProperty Name="IDR" ColumnName="IDR" />
                <ScalarProperty Name="ZP" ColumnName="ZP" />
                <ScalarProperty Name="MORE" ColumnName="MORE" />
                <ScalarProperty Name="IDI" ColumnName="IDI" />
                <ScalarProperty Name="IDNN" ColumnName="IDNN" />
                <ScalarProperty Name="IDU" ColumnName="IDU" />
                <ScalarProperty Name="DT" ColumnName="DT" />
                <ScalarProperty Name="HAND" ColumnName="HAND" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <FunctionImportMapping FunctionImportName="CountUroki" FunctionName="Хранилище ExRaspisDBModel.CountUroki" />
          <FunctionImportMapping FunctionImportName="CountUroki_Otchet_interval" FunctionName="Хранилище ExRaspisDBModel.CountUroki_Otchet_interval" />
          <FunctionImportMapping FunctionImportName="MergePlan" FunctionName="Хранилище ExRaspisDBModel.MergePlan" />
          <FunctionImportMapping FunctionImportName="pr_LoadGroup" FunctionName="Хранилище ExRaspisDBModel.pr_LoadGroup">
            <ResultMapping>
              <ComplexTypeMapping TypeName="ExRaspisDBModel.pr_LoadGroup_Result">
                <ScalarProperty Name="IDG" ColumnName="IDG" />
                <ScalarProperty Name="NAIM" ColumnName="NAIM" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="pr_LoadNagrGroup" FunctionName="Хранилище ExRaspisDBModel.pr_LoadNagrGroup">
            <ResultMapping>
              <ComplexTypeMapping TypeName="ExRaspisDBModel.pr_LoadNagrGroup_Result">
                <ScalarProperty Name="IDG" ColumnName="IDG" />
                <ScalarProperty Name="IDP" ColumnName="IDP" />
                <ScalarProperty Name="IDD" ColumnName="IDD" />
                <ScalarProperty Name="Преподаватель" ColumnName="Преподаватель" />
                <ScalarProperty Name="Дисциплина" ColumnName="Дисциплина" />
                <ScalarProperty Name="п_г" ColumnName="п/г" />
                <ScalarProperty Name="Всего" ColumnName="Всего" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="pr_LoadNagrPrepod" FunctionName="Хранилище ExRaspisDBModel.pr_LoadNagrPrepod">
            <ResultMapping>
              <ComplexTypeMapping TypeName="ExRaspisDBModel.pr_LoadNagrPrepod_Result">
                <ScalarProperty Name="IDP" ColumnName="IDP" />
                <ScalarProperty Name="IDG" ColumnName="IDG" />
                <ScalarProperty Name="IDD" ColumnName="IDD" />
                <ScalarProperty Name="Группа" ColumnName="Группа" />
                <ScalarProperty Name="Дисциплина" ColumnName="Дисциплина" />
                <ScalarProperty Name="п_г" ColumnName="п/г" />
                <ScalarProperty Name="Всего" ColumnName="Всего" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="pr_LoadPlan" FunctionName="Хранилище ExRaspisDBModel.pr_LoadPlan">
            <ResultMapping>
              <ComplexTypeMapping TypeName="ExRaspisDBModel.pr_LoadPlan_Result">
                <ScalarProperty Name="Ned_1" ColumnName="Ned_1" />
                <ScalarProperty Name="Ned_2" ColumnName="Ned_2" />
                <ScalarProperty Name="Ned_3" ColumnName="Ned_3" />
                <ScalarProperty Name="Ned_4" ColumnName="Ned_4" />
                <ScalarProperty Name="Ned_5" ColumnName="Ned_5" />
                <ScalarProperty Name="Ned_6" ColumnName="Ned_6" />
                <ScalarProperty Name="Ned_7" ColumnName="Ned_7" />
                <ScalarProperty Name="Ned_8" ColumnName="Ned_8" />
                <ScalarProperty Name="Ned_9" ColumnName="Ned_9" />
                <ScalarProperty Name="Ned_10" ColumnName="Ned_10" />
                <ScalarProperty Name="Ned_11" ColumnName="Ned_11" />
                <ScalarProperty Name="Ned_12" ColumnName="Ned_12" />
                <ScalarProperty Name="Ned_13" ColumnName="Ned_13" />
                <ScalarProperty Name="Ned_14" ColumnName="Ned_14" />
                <ScalarProperty Name="Ned_15" ColumnName="Ned_15" />
                <ScalarProperty Name="Ned_16" ColumnName="Ned_16" />
                <ScalarProperty Name="Ned_17" ColumnName="Ned_17" />
                <ScalarProperty Name="Ned_18" ColumnName="Ned_18" />
                <ScalarProperty Name="Ned_19" ColumnName="Ned_19" />
                <ScalarProperty Name="Ned_20" ColumnName="Ned_20" />
                <ScalarProperty Name="Ned_21" ColumnName="Ned_21" />
                <ScalarProperty Name="Ned_22" ColumnName="Ned_22" />
                <ScalarProperty Name="Ned_23" ColumnName="Ned_23" />
                <ScalarProperty Name="Ned_24" ColumnName="Ned_24" />
                <ScalarProperty Name="Ned_25" ColumnName="Ned_25" />
                <ScalarProperty Name="Ned_26" ColumnName="Ned_26" />
                <ScalarProperty Name="Ned_27" ColumnName="Ned_27" />
                <ScalarProperty Name="Ned_28" ColumnName="Ned_28" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="pr_LoadPrepod" FunctionName="Хранилище ExRaspisDBModel.pr_LoadPrepod">
            <ResultMapping>
              <ComplexTypeMapping TypeName="ExRaspisDBModel.pr_LoadPrepod_Result">
                <ScalarProperty Name="IDP" ColumnName="IDP" />
                <ScalarProperty Name="FAMIO" ColumnName="FAMIO" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="sp_alterdiagram" FunctionName="Хранилище ExRaspisDBModel.sp_alterdiagram" />
          <FunctionImportMapping FunctionImportName="sp_creatediagram" FunctionName="Хранилище ExRaspisDBModel.sp_creatediagram" />
          <FunctionImportMapping FunctionImportName="sp_dropdiagram" FunctionName="Хранилище ExRaspisDBModel.sp_dropdiagram" />
          <FunctionImportMapping FunctionImportName="sp_helpdiagramdefinition" FunctionName="Хранилище ExRaspisDBModel.sp_helpdiagramdefinition">
            <ResultMapping>
              <ComplexTypeMapping TypeName="ExRaspisDBModel.sp_helpdiagramdefinition_Result">
                <ScalarProperty Name="version" ColumnName="version" />
                <ScalarProperty Name="definition" ColumnName="definition" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="sp_helpdiagrams" FunctionName="Хранилище ExRaspisDBModel.sp_helpdiagrams">
            <ResultMapping>
              <ComplexTypeMapping TypeName="ExRaspisDBModel.sp_helpdiagrams_Result">
                <ScalarProperty Name="Database" ColumnName="Database" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="ID" ColumnName="ID" />
                <ScalarProperty Name="Owner" ColumnName="Owner" />
                <ScalarProperty Name="OwnerID" ColumnName="OwnerID" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="sp_renamediagram" FunctionName="Хранилище ExRaspisDBModel.sp_renamediagram" />
          <FunctionImportMapping FunctionImportName="sp_upgraddiagrams" FunctionName="Хранилище ExRaspisDBModel.sp_upgraddiagrams" />
        </EntityContainerMapping>
      </Mapping>
    </edmx:Mappings>
  </edmx:Runtime>
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
    <Connection>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
      </DesignerInfoPropertySet>
    </Connection>
    <Options>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="ValidateOnBuild" Value="true" />
        <DesignerProperty Name="EnablePluralization" Value="false" />
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
        <DesignerProperty Name="UseLegacyProvider" Value="false" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>